Dataset statistics
| Number of variables | 11 |
|---|---|
| Number of observations | 4312 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 404.2 KiB |
| Average record size in memory | 96.0 B |
Variable types
| Numeric | 11 |
|---|
GrossRevenue is highly overall correlated with QtItems and 4 other fields | High correlation |
RecencyDays is highly overall correlated with PurchasesNo and 2 other fields | High correlation |
Frequency is highly overall correlated with PurchasesNo and 2 other fields | High correlation |
ReturnsNo is highly overall correlated with ProductReturns and 3 other fields | High correlation |
QtItems is highly overall correlated with GrossRevenue and 4 other fields | High correlation |
ProductReturns is highly overall correlated with ReturnsNo and 1 other fields | High correlation |
PurchasesNo is highly overall correlated with GrossRevenue and 7 other fields | High correlation |
PurchasingDays is highly overall correlated with GrossRevenue and 7 other fields | High correlation |
ProductsNo is highly overall correlated with GrossRevenue and 4 other fields | High correlation |
PurchasingMonths is highly overall correlated with GrossRevenue and 8 other fields | High correlation |
GrossRevenue is highly skewed (γ1 = 21.48774973) | Skewed |
QtItems is highly skewed (γ1 = 22.85121717) | Skewed |
ProductReturns is highly skewed (γ1 = 26.98231359) | Skewed |
CustomerID has unique values | Unique |
RecencyDays has 103 (2.4%) zeros | Zeros |
ReturnsNo has 2823 (65.5%) zeros | Zeros |
ProductReturns has 2823 (65.5%) zeros | Zeros |
Reproduction
| Analysis started | 2023-10-15 23:00:50.954531 |
|---|---|
| Analysis finished | 2023-10-15 23:01:11.149171 |
| Duration | 20.19 seconds |
| Software version | pandas-profiling vv3.6.1 |
| Download configuration | config.json |
CustomerID
Real number (ℝ)
| Distinct | 4312 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15301.228 |
| Minimum | 12347 |
|---|---|
| Maximum | 18287 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.4 KiB |
Quantile statistics
| Minimum | 12347 |
|---|---|
| 5-th percentile | 12618.55 |
| Q1 | 13815.75 |
| median | 15299.5 |
| Q3 | 16780.25 |
| 95-th percentile | 17981.8 |
| Maximum | 18287 |
| Range | 5940 |
| Interquartile range (IQR) | 2964.5 |
Descriptive statistics
| Standard deviation | 1720.3287 |
|---|---|
| Coefficient of variation (CV) | 0.11243076 |
| Kurtosis | -1.1951977 |
| Mean | 15301.228 |
| Median Absolute Deviation (MAD) | 1482.5 |
| Skewness | 0.0019242029 |
| Sum | 65978894 |
| Variance | 2959530.9 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 17850 | 1 | < 0.1% |
| 15700 | 1 | < 0.1% |
| 15219 | 1 | < 0.1% |
| 15014 | 1 | < 0.1% |
| 14765 | 1 | < 0.1% |
| 16869 | 1 | < 0.1% |
| 15909 | 1 | < 0.1% |
| 13618 | 1 | < 0.1% |
| 16050 | 1 | < 0.1% |
| 17879 | 1 | < 0.1% |
| Other values (4302) | 4302 |
| Value | Count | Frequency (%) |
| 12347 | 1 | |
| 12348 | 1 | |
| 12349 | 1 | |
| 12350 | 1 | |
| 12352 | 1 | |
| 12353 | 1 | |
| 12354 | 1 | |
| 12355 | 1 | |
| 12356 | 1 | |
| 12357 | 1 |
| Value | Count | Frequency (%) |
| 18287 | 1 | |
| 18283 | 1 | |
| 18282 | 1 | |
| 18281 | 1 | |
| 18280 | 1 | |
| 18278 | 1 | |
| 18277 | 1 | |
| 18276 | 1 | |
| 18273 | 1 | |
| 18272 | 1 |
GrossRevenue
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 4234 |
|---|---|
| Distinct (%) | 98.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1923.3688 |
| Minimum | 12.24 |
|---|---|
| Maximum | 278778.02 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.4 KiB |
Quantile statistics
| Minimum | 12.24 |
|---|---|
| 5-th percentile | 110.9365 |
| Q1 | 300.9025 |
| median | 656 |
| Q3 | 1612.295 |
| 95-th percentile | 5660.269 |
| Maximum | 278778.02 |
| Range | 278765.78 |
| Interquartile range (IQR) | 1311.3925 |
Descriptive statistics
| Standard deviation | 8328.4019 |
|---|---|
| Coefficient of variation (CV) | 4.3301118 |
| Kurtosis | 594.65421 |
| Mean | 1923.3688 |
| Median Absolute Deviation (MAD) | 454.37 |
| Skewness | 21.48775 |
| Sum | 8293566.1 |
| Variance | 69362278 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 76.32 | 4 | 0.1% |
| 35.4 | 3 | 0.1% |
| 15 | 3 | 0.1% |
| 363.65 | 3 | 0.1% |
| 440 | 3 | 0.1% |
| 79.2 | 3 | 0.1% |
| 113.5 | 3 | 0.1% |
| 181.09 | 2 | < 0.1% |
| 324.24 | 2 | < 0.1% |
| 590 | 2 | < 0.1% |
| Other values (4224) | 4284 |
| Value | Count | Frequency (%) |
| 12.24 | 1 | < 0.1% |
| 12.75 | 1 | < 0.1% |
| 15 | 3 | |
| 17 | 1 | < 0.1% |
| 20.8 | 2 | |
| 25.5 | 1 | < 0.1% |
| 30 | 1 | < 0.1% |
| 30.6 | 1 | < 0.1% |
| 32.65 | 1 | < 0.1% |
| 34 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 278778.02 | 1 | |
| 259657.3 | 1 | |
| 189735.53 | 1 | |
| 132995.13 | 1 | |
| 123638.18 | 1 | |
| 114501.32 | 1 | |
| 88138.2 | 1 | |
| 65920.12 | 1 | |
| 62904.1 | 1 | |
| 59419.34 | 1 |
RecencyDays
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 349 |
|---|---|
| Distinct (%) | 8.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 89.626391 |
| Minimum | 0 |
|---|---|
| Maximum | 373 |
| Zeros | 103 |
| Zeros (%) | 2.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 16 |
| median | 49 |
| Q3 | 138 |
| 95-th percentile | 310 |
| Maximum | 373 |
| Range | 373 |
| Interquartile range (IQR) | 122 |
Descriptive statistics
| Standard deviation | 99.435154 |
|---|---|
| Coefficient of variation (CV) | 1.1094406 |
| Kurtosis | 0.48470823 |
| Mean | 89.626391 |
| Median Absolute Deviation (MAD) | 40 |
| Skewness | 1.2644794 |
| Sum | 386469 |
| Variance | 9887.3498 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 126 | 2.9% |
| 8 | 104 | 2.4% |
| 0 | 103 | 2.4% |
| 2 | 99 | 2.3% |
| 1 | 91 | 2.1% |
| 7 | 78 | 1.8% |
| 9 | 73 | 1.7% |
| 10 | 70 | 1.6% |
| 21 | 62 | 1.4% |
| 17 | 61 | 1.4% |
| Other values (339) | 3445 |
| Value | Count | Frequency (%) |
| 0 | 103 | |
| 1 | 91 | |
| 2 | 99 | |
| 3 | 126 | |
| 4 | 60 | |
| 5 | 22 | 0.5% |
| 6 | 42 | 1.0% |
| 7 | 78 | |
| 8 | 104 | |
| 9 | 73 |
| Value | Count | Frequency (%) |
| 373 | 7 | |
| 372 | 16 | |
| 371 | 10 | |
| 370 | 2 | < 0.1% |
| 369 | 1 | < 0.1% |
| 368 | 5 | 0.1% |
| 367 | 2 | < 0.1% |
| 366 | 7 | |
| 365 | 10 | |
| 364 | 9 |
Frequency
Real number (ℝ)
| Distinct | 1335 |
|---|---|
| Distinct (%) | 31.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.37891325 |
| Minimum | 0.0054644809 |
|---|---|
| Maximum | 6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.4 KiB |
Quantile statistics
| Minimum | 0.0054644809 |
|---|---|
| 5-th percentile | 0.010928962 |
| Q1 | 0.022701563 |
| median | 0.051282051 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 6 |
| Range | 5.9945355 |
| Interquartile range (IQR) | 0.97729844 |
Descriptive statistics
| Standard deviation | 0.5091226 |
|---|---|
| Coefficient of variation (CV) | 1.3436389 |
| Kurtosis | 6.4701184 |
| Mean | 0.37891325 |
| Median Absolute Deviation (MAD) | 0.037897024 |
| Skewness | 1.6615113 |
| Sum | 1633.8739 |
| Variance | 0.25920582 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 1309 | |
| 2 | 60 | 1.4% |
| 0.1428571429 | 22 | 0.5% |
| 0.4 | 21 | 0.5% |
| 0.02777777778 | 17 | 0.4% |
| 0.3333333333 | 17 | 0.4% |
| 0.1818181818 | 17 | 0.4% |
| 0.09090909091 | 17 | 0.4% |
| 0.25 | 16 | 0.4% |
| 0.07142857143 | 14 | 0.3% |
| Other values (1325) | 2802 |
| Value | Count | Frequency (%) |
| 0.005464480874 | 1 | < 0.1% |
| 0.005479452055 | 1 | < 0.1% |
| 0.005494505495 | 1 | < 0.1% |
| 0.005524861878 | 1 | < 0.1% |
| 0.005602240896 | 3 | |
| 0.005633802817 | 2 | |
| 0.005681818182 | 2 | |
| 0.005698005698 | 2 | |
| 0.005714285714 | 3 | |
| 0.005730659026 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 6 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 4 | 2 | < 0.1% |
| 3 | 6 | 0.1% |
| 2 | 60 | 1.4% |
| 1.833333333 | 1 | < 0.1% |
| 1.5 | 3 | 0.1% |
| 1.333333333 | 1 | < 0.1% |
| 1 | 1309 | |
| 0.8333333333 | 1 | < 0.1% |
ReturnsNo
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 23 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.77272727 |
| Minimum | 0 |
|---|---|
| Maximum | 45 |
| Zeros | 2823 |
| Zeros (%) | 65.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 4 |
| Maximum | 45 |
| Range | 45 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.975216 |
|---|---|
| Coefficient of variation (CV) | 2.5561619 |
| Kurtosis | 151.18414 |
| Mean | 0.77272727 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 9.1673092 |
| Sum | 3332 |
| Variance | 3.9014782 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2823 | |
| 1 | 836 | 19.4% |
| 2 | 288 | 6.7% |
| 3 | 139 | 3.2% |
| 4 | 92 | 2.1% |
| 5 | 37 | 0.9% |
| 6 | 32 | 0.7% |
| 7 | 21 | 0.5% |
| 9 | 8 | 0.2% |
| 11 | 5 | 0.1% |
| Other values (13) | 31 | 0.7% |
| Value | Count | Frequency (%) |
| 0 | 2823 | |
| 1 | 836 | 19.4% |
| 2 | 288 | 6.7% |
| 3 | 139 | 3.2% |
| 4 | 92 | 2.1% |
| 5 | 37 | 0.9% |
| 6 | 32 | 0.7% |
| 7 | 21 | 0.5% |
| 8 | 5 | 0.1% |
| 9 | 8 | 0.2% |
| Value | Count | Frequency (%) |
| 45 | 1 | < 0.1% |
| 44 | 1 | < 0.1% |
| 35 | 1 | < 0.1% |
| 27 | 1 | < 0.1% |
| 21 | 1 | < 0.1% |
| 18 | 2 | < 0.1% |
| 17 | 1 | < 0.1% |
| 15 | 2 | < 0.1% |
| 14 | 1 | < 0.1% |
| 13 | 5 |
QtItems
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 1766 |
|---|---|
| Distinct (%) | 41.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1133.6389 |
| Minimum | 1 |
|---|---|
| Maximum | 196556 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 46 |
| Q1 | 159 |
| median | 373.5 |
| Q3 | 978 |
| 95-th percentile | 3504.6 |
| Maximum | 196556 |
| Range | 196555 |
| Interquartile range (IQR) | 819 |
Descriptive statistics
| Standard deviation | 4696.3904 |
|---|---|
| Coefficient of variation (CV) | 4.1427569 |
| Kurtosis | 772.70619 |
| Mean | 1133.6389 |
| Median Absolute Deviation (MAD) | 272.5 |
| Skewness | 22.851217 |
| Sum | 4888251 |
| Variance | 22056083 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 88 | 19 | 0.4% |
| 120 | 18 | 0.4% |
| 72 | 16 | 0.4% |
| 128 | 15 | 0.3% |
| 106 | 15 | 0.3% |
| 78 | 14 | 0.3% |
| 146 | 14 | 0.3% |
| 150 | 14 | 0.3% |
| 84 | 13 | 0.3% |
| 160 | 13 | 0.3% |
| Other values (1756) | 4161 |
| Value | Count | Frequency (%) |
| 1 | 2 | < 0.1% |
| 2 | 4 | |
| 3 | 2 | < 0.1% |
| 4 | 7 | |
| 5 | 3 | |
| 6 | 3 | |
| 7 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 2 | < 0.1% |
| 10 | 5 |
| Value | Count | Frequency (%) |
| 196556 | 1 | |
| 76946 | 1 | |
| 76631 | 1 | |
| 69041 | 1 | |
| 64124 | 1 | |
| 63014 | 1 | |
| 61308 | 1 | |
| 57921 | 1 | |
| 56926 | 1 | |
| 49391 | 1 |
ProductReturns
Real number (ℝ)
HIGH CORRELATION  SKEWED  ZEROS 
| Distinct | 205 |
|---|---|
| Distinct (%) | 4.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.980056 |
| Minimum | 0 |
|---|---|
| Maximum | 9014 |
| Zeros | 2823 |
| Zeros (%) | 65.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 3 |
| 95-th percentile | 57 |
| Maximum | 9014 |
| Range | 9014 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 233.47567 |
|---|---|
| Coefficient of variation (CV) | 10.159926 |
| Kurtosis | 890.17853 |
| Mean | 22.980056 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 26.982314 |
| Sum | 99090 |
| Variance | 54510.887 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2823 | |
| 1 | 169 | 3.9% |
| 2 | 148 | 3.4% |
| 3 | 105 | 2.4% |
| 4 | 89 | 2.1% |
| 6 | 78 | 1.8% |
| 5 | 61 | 1.4% |
| 12 | 51 | 1.2% |
| 7 | 44 | 1.0% |
| 8 | 43 | 1.0% |
| Other values (195) | 701 | 16.3% |
| Value | Count | Frequency (%) |
| 0 | 2823 | |
| 1 | 169 | 3.9% |
| 2 | 148 | 3.4% |
| 3 | 105 | 2.4% |
| 4 | 89 | 2.1% |
| 5 | 61 | 1.4% |
| 6 | 78 | 1.8% |
| 7 | 44 | 1.0% |
| 8 | 43 | 1.0% |
| 9 | 41 | 1.0% |
| Value | Count | Frequency (%) |
| 9014 | 1 | |
| 8004 | 1 | |
| 4427 | 1 | |
| 3768 | 1 | |
| 3332 | 1 | |
| 2878 | 1 | |
| 2022 | 1 | |
| 2012 | 1 | |
| 1776 | 1 | |
| 1594 | 1 |
PurchasesNo
Real number (ℝ)
| Distinct | 56 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.2608998 |
| Minimum | 1 |
|---|---|
| Maximum | 206 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 5 |
| 95-th percentile | 13 |
| Maximum | 206 |
| Range | 205 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 7.6592577 |
|---|---|
| Coefficient of variation (CV) | 1.7975681 |
| Kurtosis | 244.21556 |
| Mean | 4.2608998 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 11.953473 |
| Sum | 18373 |
| Variance | 58.664228 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 1491 | |
| 2 | 825 | |
| 3 | 500 | 11.6% |
| 4 | 395 | 9.2% |
| 5 | 236 | 5.5% |
| 6 | 173 | 4.0% |
| 7 | 139 | 3.2% |
| 8 | 98 | 2.3% |
| 9 | 68 | 1.6% |
| 10 | 55 | 1.3% |
| Other values (46) | 332 | 7.7% |
| Value | Count | Frequency (%) |
| 1 | 1491 | |
| 2 | 825 | |
| 3 | 500 | 11.6% |
| 4 | 395 | 9.2% |
| 5 | 236 | 5.5% |
| 6 | 173 | 4.0% |
| 7 | 139 | 3.2% |
| 8 | 98 | 2.3% |
| 9 | 68 | 1.6% |
| 10 | 55 | 1.3% |
| Value | Count | Frequency (%) |
| 206 | 1 | |
| 199 | 1 | |
| 124 | 1 | |
| 97 | 1 | |
| 91 | 1 | |
| 90 | 1 | |
| 86 | 1 | |
| 72 | 1 | |
| 62 | 2 | |
| 60 | 1 |
PurchasingDays
Real number (ℝ)
| Distinct | 56 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.239564 |
| Minimum | 1 |
|---|---|
| Maximum | 207 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 5 |
| 95-th percentile | 13 |
| Maximum | 207 |
| Range | 206 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 7.59582 |
|---|---|
| Coefficient of variation (CV) | 1.7916512 |
| Kurtosis | 253.32318 |
| Mean | 4.239564 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 12.165239 |
| Sum | 18281 |
| Variance | 57.696481 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 1493 | |
| 2 | 823 | |
| 3 | 500 | 11.6% |
| 4 | 398 | 9.2% |
| 5 | 237 | 5.5% |
| 6 | 172 | 4.0% |
| 7 | 137 | 3.2% |
| 8 | 96 | 2.2% |
| 9 | 76 | 1.8% |
| 11 | 54 | 1.3% |
| Other values (46) | 326 | 7.6% |
| Value | Count | Frequency (%) |
| 1 | 1493 | |
| 2 | 823 | |
| 3 | 500 | 11.6% |
| 4 | 398 | 9.2% |
| 5 | 237 | 5.5% |
| 6 | 172 | 4.0% |
| 7 | 137 | 3.2% |
| 8 | 96 | 2.2% |
| 9 | 76 | 1.8% |
| 10 | 52 | 1.2% |
| Value | Count | Frequency (%) |
| 207 | 1 | |
| 199 | 1 | |
| 124 | 1 | |
| 93 | 1 | |
| 92 | 1 | |
| 91 | 1 | |
| 83 | 1 | |
| 72 | 1 | |
| 60 | 1 | |
| 58 | 1 |
ProductsNo
Real number (ℝ)
| Distinct | 468 |
|---|---|
| Distinct (%) | 10.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 91.809833 |
| Minimum | 1 |
|---|---|
| Maximum | 7837 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 17 |
| median | 41 |
| Q3 | 100 |
| 95-th percentile | 315.45 |
| Maximum | 7837 |
| Range | 7836 |
| Interquartile range (IQR) | 83 |
Descriptive statistics
| Standard deviation | 228.95531 |
|---|---|
| Coefficient of variation (CV) | 2.4937994 |
| Kurtosis | 481.70849 |
| Mean | 91.809833 |
| Median Absolute Deviation (MAD) | 30 |
| Skewness | 18.076734 |
| Sum | 395884 |
| Variance | 52420.533 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 84 | 1.9% |
| 9 | 76 | 1.8% |
| 6 | 76 | 1.8% |
| 15 | 69 | 1.6% |
| 11 | 68 | 1.6% |
| 1 | 68 | 1.6% |
| 28 | 67 | 1.6% |
| 8 | 67 | 1.6% |
| 5 | 66 | 1.5% |
| 7 | 65 | 1.5% |
| Other values (458) | 3606 |
| Value | Count | Frequency (%) |
| 1 | 68 | |
| 2 | 50 | |
| 3 | 55 | |
| 4 | 49 | |
| 5 | 66 | |
| 6 | 76 | |
| 7 | 65 | |
| 8 | 67 | |
| 9 | 76 | |
| 10 | 84 |
| Value | Count | Frequency (%) |
| 7837 | 1 | |
| 5670 | 1 | |
| 5095 | 1 | |
| 4577 | 1 | |
| 2697 | 1 | |
| 2379 | 1 | |
| 2060 | 1 | |
| 1818 | 1 | |
| 1672 | 1 | |
| 1636 | 1 |
PurchasingMonths
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.0839518 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 9 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.588611 |
|---|---|
| Coefficient of variation (CV) | 0.83938115 |
| Kurtosis | 2.0693461 |
| Mean | 3.0839518 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.5853553 |
| Sum | 13298 |
| Variance | 6.7009069 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 1543 | |
| 2 | 897 | |
| 3 | 546 | 12.7% |
| 4 | 398 | 9.2% |
| 5 | 283 | 6.6% |
| 6 | 175 | 4.1% |
| 7 | 113 | 2.6% |
| 8 | 99 | 2.3% |
| 9 | 76 | 1.8% |
| 10 | 64 | 1.5% |
| Other values (2) | 118 | 2.7% |
| Value | Count | Frequency (%) |
| 1 | 1543 | |
| 2 | 897 | |
| 3 | 546 | 12.7% |
| 4 | 398 | 9.2% |
| 5 | 283 | 6.6% |
| 6 | 175 | 4.1% |
| 7 | 113 | 2.6% |
| 8 | 99 | 2.3% |
| 9 | 76 | 1.8% |
| 10 | 64 | 1.5% |
| Value | Count | Frequency (%) |
| 12 | 61 | 1.4% |
| 11 | 57 | 1.3% |
| 10 | 64 | 1.5% |
| 9 | 76 | 1.8% |
| 8 | 99 | 2.3% |
| 7 | 113 | 2.6% |
| 6 | 175 | 4.1% |
| 5 | 283 | |
| 4 | 398 | |
| 3 | 546 |
| CustomerID | GrossRevenue | RecencyDays | Frequency | ReturnsNo | QtItems | ProductReturns | PurchasesNo | PurchasingDays | ProductsNo | PurchasingMonths | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| CustomerID | 1.000 | -0.078 | 0.016 | 0.023 | -0.045 | -0.068 | -0.052 | 0.000 | 0.001 | -0.004 | -0.028 |
| GrossRevenue | -0.078 | 1.000 | -0.492 | -0.443 | 0.482 | 0.931 | 0.471 | 0.806 | 0.805 | 0.787 | 0.790 |
| RecencyDays | 0.016 | -0.492 | 1.000 | 0.338 | -0.308 | -0.491 | -0.296 | -0.561 | -0.560 | -0.499 | -0.547 |
| Frequency | 0.023 | -0.443 | 0.338 | 1.000 | -0.186 | -0.410 | -0.188 | -0.581 | -0.581 | -0.392 | -0.641 |
| ReturnsNo | -0.045 | 0.482 | -0.308 | -0.186 | 1.000 | 0.450 | 0.976 | 0.502 | 0.501 | 0.411 | 0.559 |
| QtItems | -0.068 | 0.931 | -0.491 | -0.410 | 0.450 | 1.000 | 0.443 | 0.759 | 0.758 | 0.776 | 0.744 |
| ProductReturns | -0.052 | 0.471 | -0.296 | -0.188 | 0.976 | 0.443 | 1.000 | 0.485 | 0.485 | 0.396 | 0.539 |
| PurchasesNo | 0.000 | 0.806 | -0.561 | -0.581 | 0.502 | 0.759 | 0.485 | 1.000 | 0.999 | 0.731 | 0.948 |
| PurchasingDays | 0.001 | 0.805 | -0.560 | -0.581 | 0.501 | 0.758 | 0.485 | 0.999 | 1.000 | 0.731 | 0.948 |
| ProductsNo | -0.004 | 0.787 | -0.499 | -0.392 | 0.411 | 0.776 | 0.396 | 0.731 | 0.731 | 1.000 | 0.707 |
| PurchasingMonths | -0.028 | 0.790 | -0.547 | -0.641 | 0.559 | 0.744 | 0.539 | 0.948 | 0.948 | 0.707 | 1.000 |
| CustomerID | GrossRevenue | RecencyDays | Frequency | ReturnsNo | QtItems | ProductReturns | PurchasesNo | PurchasingDays | ProductsNo | PurchasingMonths | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 17850 | 5288.63 | 301 | 0.486111 | 1.0 | 1693 | 40.0 | 34.0 | 33.0 | 297.0 | 2 |
| 1 | 13047 | 3089.10 | 45 | 0.048780 | 7.0 | 1355 | 35.0 | 9.0 | 8.0 | 171.0 | 9 |
| 2 | 12583 | 6629.34 | 2 | 0.045822 | 2.0 | 4978 | 50.0 | 15.0 | 15.0 | 232.0 | 11 |
| 3 | 13748 | 948.25 | 95 | 0.017921 | 0.0 | 439 | 0.0 | 5.0 | 4.0 | 28.0 | 3 |
| 4 | 15100 | 635.10 | 329 | 0.136364 | 3.0 | 58 | 22.0 | 3.0 | 3.0 | 3.0 | 2 |
| 5 | 15291 | 4551.51 | 25 | 0.054441 | 5.0 | 2073 | 29.0 | 14.0 | 14.0 | 102.0 | 7 |
| 6 | 14688 | 5107.38 | 7 | 0.073569 | 6.0 | 3222 | 399.0 | 21.0 | 21.0 | 327.0 | 11 |
| 7 | 17809 | 5344.85 | 15 | 0.039106 | 2.0 | 2016 | 41.0 | 12.0 | 12.0 | 61.0 | 8 |
| 8 | 15311 | 59419.34 | 0 | 0.315508 | 27.0 | 37720 | 474.0 | 91.0 | 91.0 | 2379.0 | 12 |
| 9 | 16098 | 2005.63 | 87 | 0.027875 | 0.0 | 613 | 0.0 | 7.0 | 8.0 | 67.0 | 7 |
| CustomerID | GrossRevenue | RecencyDays | Frequency | ReturnsNo | QtItems | ProductReturns | PurchasesNo | PurchasingDays | ProductsNo | PurchasingMonths | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 4347 | 16000 | 12393.70 | 2 | 3.0 | 0.0 | 5110 | 0.0 | 3.0 | 3.0 | 9.0 | 1 |
| 4348 | 15195 | 3861.00 | 2 | 1.0 | 0.0 | 1404 | 0.0 | 1.0 | 1.0 | 1.0 | 1 |
| 4349 | 14087 | 181.67 | 2 | 2.0 | 1.0 | 250 | 1.0 | 1.0 | 1.0 | 69.0 | 1 |
| 4350 | 14204 | 161.03 | 1 | 1.0 | 0.0 | 82 | 0.0 | 1.0 | 1.0 | 44.0 | 1 |
| 4351 | 15471 | 469.48 | 1 | 1.0 | 0.0 | 266 | 0.0 | 1.0 | 1.0 | 77.0 | 1 |
| 4352 | 13436 | 196.89 | 1 | 1.0 | 0.0 | 76 | 0.0 | 1.0 | 1.0 | 12.0 | 1 |
| 4353 | 15520 | 343.50 | 1 | 1.0 | 0.0 | 314 | 0.0 | 1.0 | 1.0 | 18.0 | 1 |
| 4354 | 13298 | 360.00 | 0 | 1.0 | 0.0 | 96 | 0.0 | 1.0 | 1.0 | 2.0 | 1 |
| 4355 | 14569 | 227.39 | 0 | 1.0 | 0.0 | 79 | 0.0 | 1.0 | 1.0 | 12.0 | 1 |
| 4356 | 12713 | 794.55 | 0 | 1.0 | 0.0 | 505 | 0.0 | 1.0 | 1.0 | 37.0 | 1 |